Working with grids and property sheets
This topic examines the grid views, which give you the means to view the data for a group of objects and provides alternative editing methods, and the property sheets, which provide a way of looking at all the data for a single network object in a more structured way.
Grids
Grids are accessible via the Window menu or the Windows toolbar:
Examining grid data
You can display a grid of all objects of one type (e.g. all nodes, all links, etc):
- From the menu, choose , then one of the options in the sub-menu (for example, to view all nodes). The grid view is displayed.
- Use the scroll bars to move around the grid.
- Click the tabs at the bottom of the window to see objects of different types (e.g. different types of node).
- Drag the corners or edges of the window to change its size and shape.
- Drag the borders between column headings to change the widths of the columns.
- Click to the left of a row to select that object; the object is highlighted on the GeoPlan. Use Ctrl when clicking to select a number of objects; use Shift to select a group of consecutive objects.
- Click the button to close the grid view.
Grid manipulation
Freezing columns
- Keep the Node ID column visible at all times by clicking the column header (to select the whole column), then right-clicking the header and choosing .
Re-ordering columns
- Change the order of columns by clicking a column header to select it then dragging the header to the left or right. You can select several columns at once by dragging the pointer over the headers.
- Click anywhere on the grid so that the columns are no longer highlighted.
- Sort the nodes according to ground level by right-clicking the column itself (not the header) and choosing .
- Sort by ground level and then east-west position by clicking the header, Ctrl-clicking the column header, right-clicking and choosing .
- In the GeoPlan view, make a selection of nodes. Bring the selected objects to the top (leaving the others sorted as before) by selecting
- Close the grid by clicking its button.
Example of grid manipulation
The tool was used in another topic to select all reservoirs. You can do the same with the relevant grid view:
- Click the button to clear the current selection.
- Display the whole network by right-clicking the GeoPlan and selecting .
- From the menu, choose .
- Select the Reservoir tab (at the bottom of the dialog).
- Adjust the size and positions of the GeoPlan and grid windows so that you can see both clearly.
- Select a reservoir by clicking to the left of the record. The reservoir is highlighted on the GeoPlan.
- Select all reservoirs by clicking to the left of the first record and then Shift-clicking the last record.
- Right-click the GeoPlan and choose .
- Close the grid view.
Exporting grid data
It is possible to copy data to an Excel worksheet:
- For example, let us open a nodes grid and drag the X and Y columns so that they are next to the Node ID column.
- Mark the three columns, so that the data is highlighted.
- Press Ctrl+C to copy the data.
- Click Yes, to confirm copying of column headers.
- Open an Excel worksheet and press Ctrl+V to paste the data.
- Close the Excel worksheet.
- Close the Nodes grid view.
Property sheets
The data is divided up into sections showing data of similar type. Some data is common to more than one type of object, so a section may occur in more than one type of property sheet. However, property sheets can be object-specific and an example is shown below:
If the network is checked out, the property sheets are editable.